ANStr2Range

Converts a string of items into range, with custom separator. Opposite of

DBTables

Returns an array of all table names in a database. needs valid OLE database ...

ANStrSort2

Sort list of strings in ascending or descending order using pure VBA, no ...

TrimEnters

SQL Function to remove repeated Enters from a string in SQL Chr(13) + Chr(10)

URLDecode

Decodes a URL encoded string back into the original text. Similar to ...

Column2AnString_Unique

Creates list of unique items found in a column, returns string with items ...

DB_Connect_Install

Connects to SQL DB using ADODB, if driver not installed, it will attempt to ...

DB_Connect_Install.zip

Remove_Between2Quotes

Remove any char (or string) found between two quotes in a string This is an ...

ProtectString + UnProtectString

Protects or unprotects a string giving a password Using XorD and similar to ...

List of Databases

Script to list databases available in a server using ADODB connection From

DB_ExtendedProperties

Returns extended properties of a database, knowing the ADODB connection

ProfileBadge_Linkedin

Creates Linkedin profile badge for certain user as HTML output as string. ...